<%@page import="ExamresultSchool.MySqlExamresultDao"%>
<%@ page language="java" import="java.util.*,yy.*,java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'Show.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
  
 	 <%@include file="Checklogin.jsp" %>  
  	<%-- <jsp:include page="Checklogin.jsp"></jsp:include>  --%>
  	<%="考试日期" %> &nbsp;<%="成绩" %> &nbsp;<%="科目编号" %> <br>
  	<%
  		Student ss=(Student)session.getAttribute("use");
 	 	MySqlExamresultDao dao = new MySqlExamresultDao();
  		List<Examresult>lis=dao.Show(Integer.parseInt(String.valueOf(ss.getStuno())));
  		if(lis.size()==0){
  		out.print("此学号暂时没有任何成绩记录");
  		
  		}else{
  		
  		for(Examresult ex:lis ){%>
  		<%=ex.getExam_date() %> &nbsp;<%=ex.getScore() %> &nbsp;<%=ex.getSbid() %> <br>
  	
  		<% }
  }
  	 %>
  	 
  </body>
</html>

